------------------------------------------------------------------------------------------------------------------------------------------------
      name:  <unnamed>
       log:  /Users/tg2778/Dropbox/0_Reviews_RnRs/072022_JOP_Roads/v3_JOP/Replication - Roads/4_Log/11_Corruption.log
  log type:  text
 opened on:  20 Jan 2023, 16:04:13

. 
. 
. global vars "ln_sancperkm ln_maintcostperkm ln_totalcostperkm qualityunsatisfactory ac_avgcomptime"

. 
. global vars2 "ln_sancperkm ln_maintcostperkm ln_totalcostperkm ac_avgcomptime"

. 
. 
. *************************************************************
. 
. use "1_Data/AC_pre-delim_dataset.dta", clear
(Written by R.              )

. 
. egen acstateid = concat(VD01_AC_id stateid),p("_")

. 
. foreach var of varlist $vars {
  2.         egen x = std(`var')
  3.         quietly areg change_incumbentvoteshare x, absorb(statedistrict2) cluster(acstateid)
  4.         quietly estimates store `var'_1
  5.         drop x
  6. }
(119 missing values generated)
(1,119 missing values generated)
(119 missing values generated)
(1,903 missing values generated)
(117 missing values generated)

. 
. esttab *_1 using "2_Tables/Appendix_Table_G1.doc", keep(x) cells(b(star fmt(3)) se(par fmt(3))) mtitles("Sanction Cost" "Maintenance Cost" "To
> tal Cost" "Poor Quality" "Completion Time") collabels(none) title(Effect of quality of roads provision on Δ incumbent vote share) varlabel(x "
> Quality") refcat(x "\b{Pre-delimitation AC}\b0", nolabel) rtf nonotes replace substitute("\fs20" "\fs16" "\fs24" "\fs20") varwidth(16) modelwi
> dth(6)
(output written to 2_Tables/Appendix_Table_G1.doc)

. 
. *************************************************************
. 
. use "1_Data/AC_post-delim_dataset.dta", clear
(Written by R.              )

. 
. egen acstateid = concat(VD01_AC_id stateid),p("_")

. 
. foreach var of varlist $vars {
  2.         egen x = std(`var')
  3.         quietly areg change_incumbentvoteshare x, absorb(statedistrict2) cluster(acstateid)
  4.         quietly estimates store `var'_2
  5.         drop x
  6. }
(110 missing values generated)
(120 missing values generated)
(110 missing values generated)
(180 missing values generated)
(126 missing values generated)

. 
. esttab *_2 using "2_Tables/Appendix_Table_G1.doc", keep(x) cells(b(star fmt(3)) se(par fmt(3))) nomtitles nonumbers collabels(none) varlabel(x
>  "Quality") refcat(x "\b{Post-delimitation AC}\b0", nolabel) rtf nonotes append substitute("\fs20" "\fs16" "\fs24" "\fs20") varwidth(16) model
> width(6)
(output written to 2_Tables/Appendix_Table_G1.doc)

. 
. 
. ***********************************************************************
. 
. use "1_Data/PC_pre-delim_dataset_select.dta", clear
(Written by R.              )

. 
. egen pcstate = concat(PC_no_2001 stateid),p("_")

. 
. foreach var of varlist $vars {
  2.         egen x = std(`var')
  3.         quietly areg change_incumbentvoteshare x, absorb(state2) cluster(pcstate)
  4.         quietly estimates store `var'_3
  5.         drop x
  6. }
(3 missing values generated)
(129 missing values generated)
(3 missing values generated)
(240 missing values generated)
(2 missing values generated)

. 
. esttab *_3 using "2_Tables/Appendix_Table_G1.doc", keep(x) cells(b(star fmt(3)) se(par fmt(3))) nomtitles nonumbers collabels(none) varlabel(x
>  "Quality") refcat(x "\b{Pre-delimitation PC}\b0", nolabel) rtf nonotes append substitute("\fs20" "\fs16" "\fs24" "\fs20") varwidth(16) modelw
> idth(6)
(output written to 2_Tables/Appendix_Table_G1.doc)

. 
. 
. ***********************************************************
. 
. use "1_Data/PC_post-delim_dataset_select.dta", clear
(Written by R.              )

. 
. egen pcstate = concat(PC_no_2001 stateid),p("_")

. 
. foreach var of varlist $vars {
  2.         egen x = std(`var')
  3.         quietly areg change_incumbentvoteshare x, absorb(state2) cluster(pcstate)
  4.         quietly estimates store `var'_4
  5.         drop x
  6. }
(1 missing value generated)
(1 missing value generated)
(1 missing value generated)
(2 missing values generated)
(1 missing value generated)

. 
. esttab *_4 using "2_Tables/Appendix_Table_G1.doc", keep(x) cells(b(star fmt(3)) se(par fmt(3))) nomtitles nonumbers collabels(none) varlabel(x
>  "Quality") refcat(x "\b{Post-delimitation PC}\b0", nolabel) rtf nonotes append substitute("\fs20" "\fs16" "\fs24" "\fs20") varwidth(16) model
> width(6)
(output written to 2_Tables/Appendix_Table_G1.doc)

. 
. *************************************************************
. 
. 
. use "1_Data/upboothdataset_1km.dta", clear

. 
. foreach var of varlist $vars2 {
  2.         egen `var'_std = std(`var')
  3. }
(80,315 missing values generated)
(80,409 missing values generated)
(80,315 missing values generated)
(86,228 missing values generated)

. 
. global vars3 "ln_sancperkm_std ln_maintcostperkm_std ln_totalcostperkm_std qualitybadsqm ac_avgcomptime_std"

. 
. foreach var of varlist $vars3 {
  2.         gen x = `var'
  3.         quietly areg b_chgincvoteshare x, absorb(ac_id_09) cluster(uniqueboothid)
  4.         quietly estimates store `var'_5
  5.         drop x
  6. }
(80,315 missing values generated)
(80,409 missing values generated)
(80,315 missing values generated)
(87,080 missing values generated)
(86,228 missing values generated)

. 
. esttab *_5 using "2_Tables/Appendix_Table_G1.doc", keep(x) cells(b(star fmt(3)) se(par fmt(3))) nomtitles nonumbers collabels(none) varlabel(x
>  "Quality") refcat(x "\b{UP Booths (1 km)}\b0", nolabel) rtf nonotes append substitute("\fs20" "\fs16" "\fs24" "\fs20") varwidth(16) modelwidt
> h(6) addnote("\i{Notes:}\i0 The dependent variable is change in incumbent vote share measured in %. The predictor for each model refers to qua
> lity measured as indicated in column headings. The OLS specification is the same as in main OLS results. Standard errors are clustered at the 
> constituency level, except at the polling station level for UP Booths. *** p<0.001, ** p<0.01, * p<0.05")
(output written to 2_Tables/Appendix_Table_G1.doc)

. log close
      name:  <unnamed>
       log:  /Users/tg2778/Dropbox/0_Reviews_RnRs/072022_JOP_Roads/v3_JOP/Replication - Roads/4_Log/11_Corruption.log
  log type:  text
 closed on:  20 Jan 2023, 16:04:17
------------------------------------------------------------------------------------------------------------------------------------------------
